Knowledge has a beginning but no end

Shortcuts in SQL field

Ashvin Gami

2022-11-19 12:39:26

    companysql 

    select r{Name of Company} from t{Company Master@@ERP Admin} where lower(c{Name of Company}) like lower('${Name of Company}%') order by c{Name of Company}

    projectsql

    select r{Project Name} from t{Project Master@@ERP Admin} where lower(c{Project Name}) like lower('${Project Name}%') and c{Name of Company}=${Name of Company} order by c{Project Name}

    selfsql

    NATIVE:select distinct(a.c{"+Field_name()+"}) from t{"+Form_name()+"@@"+Module_name()+"} as a where lower(a.c{"+Field_name()+"}) like lower('${"+Field_name()+"}%') order by a.c{"+Field_name()+"} LIMIT 40

    sql:Code Field:Name Field:Form:Module

    No example

    hql:Code Field:Name Field:Form:Module

    No example

    Related Articles